CREATE TABLE [dbo].[TRCOPA_DESC]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[TI_COMP_PAGO] [dbo].[TD_VC_003] NOT NULL,
[CO_DESC] [dbo].[TD_VC_008] NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRCOPA_DE__CO_US__4FDCC2C0] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRCOPA_DE__FE_US__50D0E6F9] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRCOPA_DE__CO_US__51C50B32] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRCOPA_DE__FE_US__52B92F6B] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRCOPA_DESC] ADD CONSTRAINT [PK__TRCOPA_D__65F1C0C5060EB63F] PRIMARY KEY CLUSTERED  ([CO_EMPR], [TI_COMP_PAGO], [CO_DESC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRCOPA_DESC] ADD CONSTRAINT [FK__TRCOPA_DESC__1C1DF2EF] FOREIGN KEY ([CO_EMPR], [TI_COMP_PAGO]) REFERENCES [dbo].[TTTIPO_COPA] ([CO_EMPR], [TI_COMP_PAGO])
GO
